Canonical case

https://gyazo.com/a427951eb358f5b335b155f79a86f953

Trim space and _ and written in upper case

In Java code: str.replaceAll("_", "").replaceAll("\\s", "").toUpperCase(Locale.ENGLISH))

Example

table:list

Original string String in caonical case

playerId PLAYERID

player_id PLAYERID

player id PLAYERID